if not exists
(select * from syscolumns where id=object_id('tb_ErpOrderProductList') and name='OPlist_Batch')
begin
	alter table tb_ErpOrderProductList add OPlist_Batch  nvarchar(10) NULL
end
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'tb_ErpOrderProductList', N'COLUMN',N'OPlist_Batch'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpOrderProductList', @level2type=N'COLUMN',@level2name=N'OPlist_Batch'
GO

if not exists
(select * from syscolumns where id=object_id('tb_ErpWeddingService') and name='Ws_Unit')
begin
	alter table tb_ErpWeddingService add Ws_Unit  nvarchar(10) NULL
end
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'tb_ErpWeddingService', N'COLUMN',N'Ws_Unit'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpWeddingService', @level2type=N'COLUMN',@level2name=N'Ws_Unit'
GO